# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import  openpyxl

myBook = openpyxl.load_workbook('城市排名表.xlsx',data_only=True)
mySheet=myBook.active

myRows=list(mySheet.values)[1:]
mySet={myRow for myRow in myRows if '广州' in myRow[1]}
while mySheet.max_row>1:
	mySheet.delete_rows(2)

for myRow in mySet:
	mySheet.append(myRow)
myBook.save('结果表-城市排名表.xlsx')

